﻿IF EXISTS (SELECT * FROM sysobjects WHERE type='V' AND name='AdministrativeDecision_View' )
BEGIN 
  DROP VIEW AdministrativeDecision_View
END
GO
CREATE VIEW AdministrativeDecision_View
AS
  SELECT  A.*,B.EnterpriseName FROM AdministrativeDecision A JOIN Enterprises_View B ON A.EnterpriseID=B.EnterpriseID
GO